Why is NULL more dangerous than 0?
How SQL's "unknown" value quietly hides broken data that a `0` never could.
Key takeaways
- three-valued logic
- NOT NULL DEFAULT 0
0 is a known, concrete value — it means "zero, exactly." NULL means "unknown / not applicable / missing" — it's the absence of a value. SQL treats them completely differently: | Be…